Release 10.1A: OpenEdge Development:
Progress Dynamics Advanced Development

Enabling caching for an SDO

The SmartDataObject Properties dialog box for an SDO instance allows you to configure caching for an SDO. You use the Share data (Shared property) and Cache data (CacheDuration property) options to accomplish this.

First, these two options are not available if:

Partition is set to None.
Read data in batches option is selected.

In other words, caching does not make sense if no AppServer partition is available and if the SDO will be batched.

To configure SDO caching:

Select an SDO instance, right-click, and choose Object Properties. The SmartDataObject Properties dialog box appears, as shown:



Select Cache data. SDO data will now be cached for the whole session.
(Optional) If you want a timed cache, select Timed cache and enter a value for Hours, for minutes, or both.
Select Share data. Cached SDO data will now be shared among all instances.